<!-- ************************************************************************************************************ -->
<!-- fileName          : EditPostsleftListName.jsp 																		  -->
<!-- author            : 马文军 																					  --> 
<!-- createDate        : 2014/05/09 																			  -->
<!-- summary           : admin端  “文章列表（左）” 编辑列表名称按钮对应编辑页面											  		  -->
<!-- modifiedBy        : 马文军																				      -->
<!-- ************************************************************************************************************ -->

<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>EditPostsleftListName</title>
<script type="text/javascript" src="../../js/jquery.js"></script>
<script type="text/javascript" src="../../js/validator.js"></script>
<script type="text/javascript">
$.ajaxSetup ({
   	cache: false //关闭AJAX相应的缓存
});
</script>
<style type="text/css">
body{
background-image:url(../../image/admin_bg.png);
background-repeat:repeat-x;
margin-left: 0px;
margin-top: 0px;
margin-right: 1px;
margin-bottom: 0px;
font-family:Microsoft YaHei;
font-size:13px;
}

h2{
font-family:Microsoft YaHei;
color:#fff;
margin: 5px 5px 5px 5px;
font-size:16px;
}

</style>
</head>
<body>

<%
	//设置请求的字符编码以支持中文
	request.setCharacterEncoding ("utf-8");

	//获取请求参数	

	//从web.xml获取全局参数
	String drv=config.getServletContext().getInitParameter("DBDriver");
	String url=config.getServletContext().getInitParameter("DBURL");
	String uid=config.getServletContext().getInitParameter("DBUser");
	String pwd=config.getServletContext().getInitParameter("DBPass");
	
	//构建SQL字符串和JDBC对象
	String strSQL = "SELECT * FROM immie0_immi.postsleft  where name='Title+' and content_name='Title-' ";	//id name content_name content date
	Connection conn = null;
	PreparedStatement pstmt = null;	
	ResultSet rs = null;
	
	try {
		Class.forName(drv).newInstance();
		conn = DriverManager.getConnection(url,uid,pwd);
		pstmt = conn.prepareStatement(strSQL);		
		
		rs = pstmt.executeQuery();
%>

<h2>编辑账号</h2>
	<div style="margin:10px auto; width:250px;">
		<form id="listnameForm" method="post" action="UpdatePostsleftListName.do">
		<table style="text-align:center; ">
			<tr>
			<%if(rs.next()){%>
            	<td><font>原列表名称：</font><input type="text"  readonly value=" <%=rs.getString(4) %> " /><input type="text" name="flag" id="flag" value="has" style="display:none;"/></td>  
            <%} 
            else{%>
            	<td><font>原列表名称：</font><input type="text"  readonly value="文章列表" /><input type="text" name="flag" id="flag" value="nothas" style="display:none;"/></td>  
            <%} %>
			</tr>
			<tr>
            	<td><font>新列表名称：</font><input type="text" name="content" id="content"   /></td>  
			</tr>
			<tr>
				<td><input type="submit" value="保存修改" /></td>
			</tr>	
		</table>
		</form>
	</div>

<%		
	} catch (ClassNotFoundException e) {
		e.printStackTrace();
	} catch (InstantiationException e) {
	    e.printStackTrace();
	} catch (IllegalAccessException e) {
		e.printStackTrace();
	} catch (SQLException e) {
		e.printStackTrace();
	} 
	finally {
		if (rs != null) {
			rs.close();
			rs = null;
		}
		if (pstmt != null) {
			pstmt.close();
			pstmt = null;
		}		
		if (conn != null) {
			conn.close();
			conn = null;
		}
	}
	
	String result = request.getParameter("result");
	if(result!=null){out.println("<script>alert('列表名称修改成功!');</script>");}
%>

</body>
</html>